﻿CREATE TABLE [dbo].[WxPayAlarm]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [AppId] NVARCHAR(50) NULL, 
    [ErrorType] NVARCHAR(50) NULL, 
    [Description] NVARCHAR(500) NULL, 
    [AlarmContent] NVARCHAR(1000) NULL, 
    [TimeStamp] NVARCHAR(50) NULL, 
    [AppSignature] NVARCHAR(50) NULL, 
    [SignMethod] NVARCHAR(50) NULL, 
    [RecCreateDt] DATETIME NOT NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'主键，自增长',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayAlarm',
    @level2type = N'COLUMN',
    @level2name = N'Id'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'字段名称：公众号 id',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayAlarm',
    @level2type = N'COLUMN',
    @level2name = N'AppId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'错误类型',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayAlarm',
    @level2type = N'COLUMN',
    @level2name = N'ErrorType'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'错误描述',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayAlarm',
    @level2type = N'COLUMN',
    @level2name = N'Description'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'错误详情',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayAlarm',
    @level2type = N'COLUMN',
    @level2name = N'AlarmContent'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'时间戳',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayAlarm',
    @level2type = N'COLUMN',
    @level2name = N'TimeStamp'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'paySign 所述的签名方式生成，参不签名的字段为： appid',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayAlarm',
    @level2type = N'COLUMN',
    @level2name = N'AppSignature'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'签名方式',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayAlarm',
    @level2type = N'COLUMN',
    @level2name = N'SignMethod'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'记录创建时间',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayAlarm',
    @level2type = N'COLUMN',
    @level2name = N'RecCreateDt'